package net.knightwatch.kwtools.database;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class RadioButtonAnswersTable {
	private static final String TAG = "RadioButtonAnswersTable";
	public static final String TABLE_RADIOBUTTON_ANSWERS = "RadioButtonAnswers";
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_ANSWER_ID	= "answerId";
	public static final String COLUMN_ANSWER_TEXT = "answerText";
	
	private static final String DATABASE_CREATE = "CREATE TABLE "
			+ TABLE_RADIOBUTTON_ANSWERS
			+ " ( "
			+ COLUMN_ID + " integer primary key autoincrement,"
			+ COLUMN_ANSWER_ID + " integer not null,"
			+ COLUMN_ANSWER_TEXT + " text not null"
			+ ");";
public static void onCreate(SQLiteDatabase database) {
		
		try {
			Log.i(TAG, "Creating " + TABLE_RADIOBUTTON_ANSWERS + " Table");
			Log.d(TAG, DATABASE_CREATE);
			database.execSQL(DATABASE_CREATE);
		} catch (Exception e) {
			Log.d(TAG, "Unable to create the database");
		}
	}
	
	public static void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion){
		
	}
}
